GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

AP_CLAIM_ICD_PROC.CLAIM_ID

AP_CLAIM_ICD_PROC.CLAIM_ID

AP_CLAIM_ICD_PROC.CLAIM_ID

AP_CLAIM_ICD_PROC.CLAIM_ID

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

GEO_BENE_SK|CLM_DT_SGNTR_SK|CLM_TYPE_CD|CLM_NUM_SK

CLM_VALUES.ICN

CLM_VALUES.ICN

If AP_CLAIM.WORKFLOW_C IN ( 4, 5 ) then AP_CLAIM.ACCT_NUM_WITH_VEN Otherwise AP_CLAIM.CLAIM_ID

If AP_CLAIM.WORKFLOW_C IN ( 4, 5 ) then AP_CLAIM.ACCT_NUM_WITH_VEN Otherwise AP_CLAIM.CLAIM_ID

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

If CLM_LINE_FROM_DT < 1/1/1753 or CLM_LINE_FROM_DT = 12/31/9999 then NULL Otherwise CLM_LINE_FROM_DT

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

If CLM_PRCDR_PRFRM_DT < 1/1/1753 or CLM_PRCDR_PRFRM_DT = 12/31/9999 then NULL Otherwise CLM_PRCDR_PRFRM_DT

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

If CLM_LINE_FROM_DT < 1/1/1753 or CLM_LINE_FROM_DT = 12/31/9999 then NULL Otherwise CLM_LINE_FROM_DT

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

If CLM_LINE_FROM_DT < 1/1/1753 or CLM_LINE_FROM_DT = 12/31/9999 then NULL Otherwise CLM_LINE_FROM_DT

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

Time Zone: Unspecified

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

Time Zone: Unspecified

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

Time Zone: Unspecified

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

Time Zone: Unspecified

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

The preferred id will be used from "BENE_HIC_NUM" if populated; otherwise the fallback id will be used from "MBI"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If PAT_ID is NULL then IDENT_BUNDLE_ID Otherwise PAT_ID

If PAT_ID is NULL then "EpicExternalIDBundleID" Otherwise "EpicPatientId"

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId component configuration for ReceivedClaimFact Otherwise NULL

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "EpicPayorId" Otherwise "NotApplicable"

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId component configuration for ReceivedClaimFact Otherwise NULL

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "EpicPayorId" Otherwise "NotApplicable"

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId component configuration for ReceivedClaimFact Otherwise NULL

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "EpicPayorId" Otherwise "NotApplicable"

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId component configuration for ReceivedClaimFact Otherwise NULL

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "EpicPayorId" Otherwise "NotApplicable"

If PRPAYAMT is NULL or PRPAYAMT = 0 then CmsPayorEpicId Otherwise NotApplicable

If PRPAYAMT is NULL or PRPAYAMT = 0 then EpicPayorId Otherwise NotApplicable

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId Otherwise NULL

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then EpicPayorId Otherwise NotApplicable

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId Otherwise NULL

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then EpicPayorId Otherwise NotApplicable

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId Otherwise NULL

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then EpicPayorId Otherwise NotApplicable

If PRPAYAMT is NULL or PRPAYAMT = 0 then CmsPayorEpicId Otherwise NotApplicable

If PRPAYAMT is NULL or PRPAYAMT = 0 then EpicPayorId Otherwise NotApplicable

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId Otherwise NULL

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then EpicPayorId Otherwise NotApplicable

If claim is inpatient, skilled nursing, or hospice:

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then CmsPayorEpicId Otherwise NULL

Otherwise if claim is Part B:

If PRPAYAMT is NULL or PRPAYAMT = 0 then CmsPayorEpicId Otherwise NotApplicable

If claim is inpatient, skilled nursing, or hospice:

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then EpicPayorId Otherwise NotApplicable

Otherwise if claim is Part B:

If PRPAYAMT is NULL or PRPAYAMT = 0 then EpicPayorId Otherwise NotApplicable

If PRIM_PAYOR_ID is not NULL then "EpicPayorId" Otherwise "NotApplicable"

If PRIM_PAYOR_ID is not NULL then "EpicPayorId" Otherwise "NotApplicable"

AP_CLAIM_3.PRIM_PAYOR_ID

If AP_CLAIM_3.PRIM_PAYOR_ID is not NULL then "EpicPayorId" Otherwise "NotApplicable"

AP_CLAIM_3.PRIM_PAYOR_ID

If AP_CLAIM_3.PRIM_PAYOR_ID is not NULL then "EpicPayorId" Otherwise "NotApplicable"

If PRIM_PAYOR_ID is not NULL then "EpicPayorId" Otherwise "NotApplicable"

If PRIM_PAYOR_ID is not NULL then "EpicPayorId" Otherwise "NotApplicable"

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId component configuration for ReceivedClaimFact

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "NotApplicable" Otherwise "EpicPayorId"

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId component configuration for ReceivedClaimFact

If CLM_NCH_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "NotApplicable" Otherwise "EpicPayorId"

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId component configuration for ReceivedClaimFact

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "NotApplicable" Otherwise "EpicPayorId"

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId component configuration for ReceivedClaimFact

If CLM_PRMRY_PYR_CD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then "NotApplicable" Otherwise "EpicPayorId"

If PRPAYAMT is NULL or PRPAYAMT = 0 then NULL Otherwise CmsPayorEpicId

If PRPAYAMT is NULL or PRPAYAMT = 0 then NotApplicable Otherwise EpicPayorId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NotApplicable Otherwise EpicPayorId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NotApplicable Otherwise EpicPayorId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NotApplicable Otherwise EpicPayorId

If PRPAYAMT is NULL or PRPAYAMT = 0 then NULL Otherwise CmsPayorEpicId

If PRPAYAMT is NULL or PRPAYAMT = 0 then NotApplicable Otherwise EpicPayorId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NULL Otherwise CmsPayorEpicId

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NotApplicable Otherwise EpicPayorId

If claim is inpatient, skilled nursing, or hospice:

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NotApplicable Otherwise EpicPayorId

Otherwise if claim is Part B:

If PRPAYAMT is NULL or PRPAYAMT = 0 then NULL Otherwise CmsPayorEpicId

If claim is inpatient, skilled nursing, or hospice:

If PRPAYCD = NULL-Medicare is primary payer, C-Conditional payment by Medicare; future reimbursement expected, M-Override Code: EGHP services involved, N-Override Code: non-EGHP services involved, Y-Other secondary payer investigation shows Medicare as primary payer, or Z-Medicare is primary payer then NotApplicable Otherwise EpicPayorId

Otherwise if claim is Part B:

If PRPAYAMT is NULL or PRPAYAMT = 0 then NotApplicable Otherwise EpicPayorId

If claim is inpatient, skilled nursing, or hospice then CLM_PROVIDER Otherwise NULL

If LOC_ID is not NULL then LOC_ID Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise if LN_SVC_FAC_NPI is not NULL and the number of services has not been modified in the system then LN_SVC_FAC_NPI Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise if LN_SVC_FAC_NPI is not NULL then LN_SVC_FAC_NPI Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise if LN_SVC_FAC_NPI is not NULL and the number of services has not been modified in the system then LN_SVC_FAC_NPI Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"

If LOC_ID is not NULL then LOC_ID Otherwise if LN_SVC_FAC_NPI is not NULL and the number of services has not been modified in the system then LN_SVC_FAC_NPI Otherwise SVC_FAC_NPI

If LOC_ID is not NULL then "EpicFacilityProfileId" Otherwise "FacilityNpi"